<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>

<?php
include "../config/config.inc.php";
//connect to mysql database
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM bidders";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

?>



  <title>NEW Project</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="/style/detail.css" >

  <!-- Hack to avoid flash of unstyled content in IE -->
  <script> </script>
</head><body id="onecolumn">
  <div id="container">
    <div class="wrapper">
      <div id="header">
        <div class="wrapper">
          <h1 id="page-title"><div id="g_title">New Project</div></h1>
          <div style="clear: both;"></div>

          <p class="description"><a href="./">|Home|</a></p>
		  <div id="g_description">
		  	  

		  </div>
          <div style="clear: both;"></div>
        </div>
      </div>
      <!-- /editable --><!-- /wrapper --><!-- /header -->
      <div id="main-content">
        
        <div class="wrapper">
          <div class="content-item">
			</div>
			<div id="g_body">
			<form action="./insert.php" method="post">
				<p><b>Project Name:</b> <input type="text" name="project" /></p>
				<p><b>Bidder Name:</b>
					<select name='bidder'>
					<?php
					$i=0;
					while ($i < $num) {
					$name=mysql_result($result,$i,"name");
					$ID=mysql_result($result,$i,"ID");
					echo" <option Value='$ID' >". $name ."</option></br>";
					$i++;
					}
					?>
					</select></p>
				<p><b>Bid Date:</b> <input type="text" name="biddate" /></p>
				<p><b>Bid Amount:</b> <input type="text" name="bidamount" /></p>
				<p><b>Alternate Amount:</b> <input type="text" name="altamount" /></p>
				<p><b>State:</b> <input type="text" name="location" /></p>
				<p><b>City:</b> <input type="text" name="city"/></p>
				<p><b>General Contractor:</b><input type="text" name="gc" /></p>
				<p><b>Comments:</b><textarea name="comments" rows="3" cols="25"></textarea></p>
				<p><input type="submit" /></p>
			</form>

			
			</div>
		  </div>
          <div style="clear: both;"></div>
        </div>
      </div>
      <!-- /wrapper --><!-- /main-content -->
      <div id="footer"><div class="wrapper">
        <hr>
        <p></p><div id="g_footer">&nbsp;</div>
        <div style="clear: both;"></div>
      </div></div>
      <!-- /wrapper --><!-- /footer -->
    </div>
  </div>
<!-- /wrapper --><!-- /container -->

<div id="extraDiv1"><span></span></div><div id="extraDiv2"><span></span></div>
<div id="extraDiv3"><span></span></div><div id="extraDiv4"><span></span></div>
<div id="extraDiv5"><span></span></div><div id="extraDiv6"><span></span></div>

</body></html>